Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
KeyCustomerGeographicSegmentID (PK) | Token identifier for a KeyCustomerGeographicSegmentID | ID_KY_CT_GEO_SGMT | Identity | integer | |
CustomerID (FK) | A unique system assigned identifier for a person or organization that purchases a product or service from the retailer. | ID_CT | Identity | integer | KeyCustomer(PA_KY_CT) |
StatusCode | Indicates the status of this KeyCustomerGeographicSegment. Valid values are A - Active I - Inactive Note that ONLY one instant of the KeyCustomerGeographicSegment entity typemay be active at a time. | CD_STS | Code2Status | char(2) | |
EffectiveDate | Date this KeyCustomer is using the GeographicSegment (place). | DC_EF | EffectiveDate | date | |
ExpirationDate | Date this KeyCustomer is no longer using the GeographicSegment (place). | DC_EP | ExpirationDate | date | |
CustomerPlaceUsageTypeCode (FK) | Defines a valid kind of key customer geographic segment (place or location) usage. Valid values include: RESIDENCE WORK SHOPPING OTHER | CD_CT_PLC_USG | Code | varchar(20) | CustomerPlaceUsageType(LU_CT_PLC_USG) |
ISO_3166-2CountrySubDivisionID (FK) | Token ID assigned to uniquely identify all country-primary subdivision instances. This token is non-signifcant and should be automatically generated. | ID_ISO_3166_2_CY_SBDVN | Identity | integer | ISO3166-2CountrySubdivision(CO_ISO3166_2_PRMRY_SBDVN) |
PostalCodeID (FK) | A token identifier for a generic postal code. Postal codes vary in format, structure and content from one country to another. This generic ID ensures that each postal code is unique across ALL COUNTRIES. | ID_PSTL_CD | Identity | integer | PostalCodeReference(LU_PSTL_CD_RFC) |
GeographicLocationID (FK) | Token ID for a GeographicLocation | ID_GEO_LCN | Identity | integer | GeophysicalLocation(CO_GEO_LCN) |